package com.example.mybatispractice.mapper;

import com.example.mybatispractice.model.ArticleInfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * Created with IntelliJ IDEA.
 * Description:
 * User: hp
 * Date: 2025-01-18
 * Time: 15:12
 */
@Mapper
public interface ArticleInfoMapper {
    @Select("select * from article_info ta " +
            "left join user_info tb on ta.uid = tb.id " +
            "where ta.id = #{id}")
    ArticleInfo selectArticleInfoAndUserInfo(Integer id);
}
